Dashboard 02 - Creating Year Over Year (YOY) Crimes Map 19
Next is to create Year Over Year (YOY) Crimes Map in the 2nd dashboard / page.
Step 1: Create a Year Over Year (YOY) Crimes Map
In Power BI Desktop, click on the dashboard / page, RaleighPoliceIncidents-District
Visualizations
Click the Map icon
Fields
Select the following:
A_KeyMeasures -> .Total_Case_Numbers - Under Visualizations, drag & drop it in the Tooltips section.
A_KeyMeasures -> .YOY_Total_Case_Numbers% - Under Visualizations, drag & drop it in the Size section.
A_KeyMeasures -> Latitude - Under Visualizations, drag & drop it in the Latitude section.
A_KeyMeasures -> Longitude - Under Visualizations, drag & drop it in the Longitude section.
Visualizations
Fields tab
Under Fields tab, click on the down arrow -> Rename for this visual and rename the fields as follows:
.Total_Case_Numbers = Total Police Incidents
.YOY_Total_Case_Numbers= YOY Police Incidents
Latitude = Latitude
Longitude = Longitude
Format tab
Similar to the previously created map , set up the format as follows:
Under Format -> General: X Position = 764 , Y Position = 189 , Width = 635 , Height = 392
Under Format -> Data Colors -> click fx for Expression -> Format by = Color Scale, Based on Field = .YOY_Total_Case_Numbers% , Minimum -> Custom Color = 008000 and Value = 0.000001 , Center -> Custom Color = F5FF00 and Value = 0.25 , Maximum -> Custom Color = FF0000 and Value = 1
Under Format -> Category -> Set it to OFF
Under Format -> Bubbles -> Size = 10
Under Format -> Map Controls -> Auto Zoom = ON , Zoom Buttons = ON
Under
Format -> Title -> Set it to OFF
Under Format -> Border -> Set it to ON , Color = 666666
Step 2: Add Legend image
Add a legend image to the map.
Import the image by clicking on Insert -> Image -> browse to the extracted folder ->
template and select the image YOYCrimeRateLegend_2020-12-16_115716.jpg
Format tab
Under Format -> General: X Position = 764 , Y Position = 144 , Width = 635 , Height = 45
Under Format -> Set all other options to OFF
Step 3 - Add filter(s)
Filters
On the map, If there is any location outside the Raleigh area, right-click on it and select Exclude.When finished, save project.
For tips on how to create maps in Power BI Desktop: